package se137.hrbust.hlgshopping137.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Result;
import org.apache.ibatis.annotations.Select;
import se137.hrbust.hlgshopping137.entity.User137;

@Mapper
public interface UserMapper137 extends BaseMapper<User137> {
   @Select("select * from tb_user137 where FUserCode137=#{usercode} limit 1")
    @Result(property = "userId137",column = "FUserId137")
   @Result(property = "userCode137",column = "FUserCode137")
   @Result(property = "userName137",column = "FUserName137")
   @Result(property = "userPass137",column = "FUserPass137")
   @Result(property = "userRole137",column = "FUserRole137")
   @Result(property = "userPhone137",column = "FUserPhone137")
   @Result(property = "userEmail137",column = "FUserEmail137")
   User137 findUserByUserCode(String usercode);
}